2015-04-20 - 18610 - Spec - Service level report #CrystalReportDevelopment
SPECIFICATIONS
18610 - Service level report
Requirement Summary
Need to design new SL100 service level report by excluding the list of all orders that have been on hold ever.
Admin Info
Purpose
|
Need to design new SL100 service level report by excluding the list of all orders that have been on hold.
|
Requested By
|
Paul Gils
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
04/20/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SL100
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
06
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
06
|
|
TOTAL
|
16
|
References
Prior Tickets
None
Documents
List of Sales Orders to be excluded for EMEA region is attached here:
EMEA Orders on Credit Block.xls
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
SL100 crystal report excluding the given list of sales orders that were on hold.
In Scope:
SL100 EMEA report.
Out of Scope:
Other regional SL100 reports.
Solution Summary
1) Need to create new BEx query Z_SSL03_TEMP similar to the EMEA version of SL100.
2)
Need to create the crystal report & point it to the new BEx Query.
3) Need to develop new filter condition in crystal report to exclude the list of sales orders as attached above.
4) Transport is not required as the BEx query is copied from existing query.
Solution Details
1) Need to create new BEx query Z_SSL03_TEMP similar to the EMEA version of SL100 & add new field Sales Document number.
2) Add Sales Document number field (0DOC_NUM) to free characteristics pane inorder to exclude the list of sales orders as attached above and point to the crystal report.
3) Need to update the query connection.
4) Need to establish the link between BEx Query field and Excel field.
5) Need to develop new filter condition in order to exclude given sales orders as attached.
Issues
Format of the Sales document number in Excel sheet and the BEx query should be same to exclude the orders.